USE [WEALTHDB]
GO

/****** Object:  Table [dbo].[ziChanSetting]    Script Date: 03/01/2013 00:50:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ziChanSetting](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[txtName] [nvarchar](50) NULL,
	[txtPhone] [nvarchar](50) NULL,
	[txtHealth] [nvarchar](500) NULL,
	[txtCost] [nvarchar](500) NULL,
	[drpWorkType] [nvarchar](50) NULL,
	[isMyComp] [bit] NULL,
	[moneyFrom] [nvarchar](500) NULL,
	[txtMoney] [nvarchar](100) NULL,
	[drpHomeCost] [nvarchar](50) NULL,
	[txtTZFX] [nvarchar](100) NULL,
	[agoBuyList] [nvarchar](500) NULL,
	[tuoZiGuanZhu] [nvarchar](500) NULL,
	[ziXunFrom] [nvarchar](500) NULL,
	[txtTotalMoney] [nvarchar](100) NULL,
	[txtJYBaozhang] [nvarchar](100) NULL,
	[txtGoalEndData] [nvarchar](50) NULL,
	[txtGoalDesc] [nvarchar](100) NULL,
	[txtGoalMoney] [nvarchar](50) NULL,
	[txtGoalDesc2] [nvarchar](50) NULL,
	[yearInMoney] [nvarchar](50) NULL,
	[yearOutMoney] [nvarchar](50) NULL,
	[txtGZ] [nvarchar](50) NULL,
	[txtKX] [nvarchar](50) NULL,
	[txtWifeMoney] [nvarchar](50) NULL,
	[txtHospital] [nvarchar](50) NULL,
	[txtPrize] [nvarchar](50) NULL,
	[txtEducation] [nvarchar](50) NULL,
	[txtLiXi] [nvarchar](50) NULL,
	[txtBX] [nvarchar](50) NULL,
	[txtRent] [nvarchar](50) NULL,
	[txtQTZC] [nvarchar](50) NULL,
	[txtQTSR] [nvarchar](50) NULL,
	[txtPayRate] [nvarchar](50) NULL,
	[txtSRRate] [nvarchar](50) NULL,
	[ziChan] [nvarchar](50) NULL,
	[fuZhai] [nvarchar](50) NULL,
	[txtCushType] [nvarchar](50) NULL,
	[txtGJJ] [nvarchar](50) NULL,
	[txtGDSY] [nvarchar](50) NULL,
	[txtGRJD] [nvarchar](50) NULL,
	[txtFDSY] [nvarchar](50) NULL,
	[txtSYZF] [nvarchar](50) NULL,
	[txtBDC] [nvarchar](50) NULL,
	[txtQTFZ] [nvarchar](50) NULL,
	[txtBXType] [nvarchar](50) NULL,
	[txtQTZCType] [nvarchar](100) NULL,
	[txtKTZGM] [nvarchar](100) NULL,
 CONSTRAINT [PK_ziChanSetting] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

